DTSToSeconds (DateTimeString)

Basic and Crystal syntax.

Arguments

DateTimeString is a string including a Date and a Time value.

Returns

Whole Number

Action

Evaluates the string specified and converts the Time value to the number of seconds from 00:00:00 (12:00 midnight) to the specified time.

Examples

The following example is applicable to Crystal syntax:

DTSToSeconds("2000/01/13 11:30:15")

Returns 41415.

Comments

Instead of using the DTSToSeconds function, you can use:

DateDiff ("s", #12:00 am#, CDateTime (CDate(0,0,0), CTime (DateTimeString)))

The above expression is able to convert more types of strings.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com